package org.hy.persistence.global;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.hy.domain.global.Sue;

public interface SueMapper {
	Sue findSueById(Integer id);
	
	List<Sue> findSuesByAdministratorId(@Param("administratorId") int administratorId,@Param("offset")int offset,@Param("size")int size);
	/**
	 * 根据不同的举报点查找
	 * @param location
	 * @param offset
	 * @param size
	 * @return
	 */
	List<Sue> findSuesByLocation(@Param("location") int location,@Param("offset")int offset,@Param("size")int size);
	
	/**
	 * 根据举报人查找
	 * @param whoSueId
	 * @param offset
	 * @param size
	 * @return
	 */
	List<Sue> findSuesByWhoSueId(@Param("whoSueId") int whoSueId,@Param("offset")int offset,@Param("size")int size);
	
	/**
	 * 根据被举报人查找
	 * @param whoSuedId
	 * @param offset
	 * @param size
	 * @return
	 */
	List<Sue> findSuesByWhoSuedId(@Param("whoSuedId") int whoSuedId,@Param("offset")int offset,@Param("size")int size);
	
	int insertSue(Sue sue);
	
	int updateSue(Sue sue);
	
	int deleteSue(Integer id);
	
}
